Host-based SSD controller array startup Pliops says it has boosted Oracle MySQL transactions/sec 3.4 times with its XDP product offloading server CPUs.

Pliops’ eXtreme Data processor (XDP) is a PCIe-connected storage controller card that implements a key:value storage-based controller for a group of SSDs, offloading low-level storage functions from a host x86 processor. Its XDP-Rocks software accelerates key-value based applications such as MySQL, MyRocks, Redis, KV-Rocks, TiDB, Kafka, Spark and others.

Pliops SVP Marius Tudor said: “As is so often the case in today’s economic environment, MySQL users are challenged to do more with less. … Pliops and Oracle are providing customers with value that they would not otherwise see without spending more money on new on-prem infrastructure,” meaning more or bigger servers. 

Oracle MySQL Enterprise Edition is its commercial product based on MySQL Community Edition, with added security, encryption, auditing, high-availability, scalability extensions, online backup, monitoring, management, visual database design and SQL development tools, along with Oracle Premier support.

The Pliops people say that adding XDP to the Oracle MySQL mix also provides up to 2x more users and 2x more instances per node with a 50 percent reduction in latency, as well as the transactions/sec boost. On top of that, an XDP-boosted MySQL system can support an up to 6x increase in usable database capacity. 

All-in-all, the added XDP reduces the overall cost of the MySQL installation by enabling it to support more and faster transactions at a lower cost/TB and lower cost/transaction, we’re told.

Read more here.